
<ul class="nav nav-tabs nav-stacked nav-coupon-category" id="flexCategory" data-breakpoint="800">
    <li class="active">
        <a><i class="icon-ticket"></i>Danh mục sách</a>
    </li>
    <li>
        <?php
                    $sql = "SELECT * FROM LoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 1";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

        ?>
            <a><i class="icon-globe"></i>
                <span><?php echo $row["TenLoaiSach"]; ?></span>
            </a>
        <?php
                                                            } //Đóng while
        ?>

        <ul>
        <?php
                        $sql = "SELECT * FROM ChiTietLoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 1";
                        $result = DataProvider::ExecuteQuery($sql);
                        while($row = mysql_fetch_array($result)){
            ?>

                                <li>
                                    <a href="index.php?a=6&dms=<?php echo $row["MaChiTietLoaiSach"]; ?> ">
                                        <span><?php echo $row["TenChiTietLoaiSach"]; ?></span>
                                    </a>
                                </li>


            <?php
                        }
            ?>
            </ul>
    </li>

    <li>
        <?php
                    $sql = "SELECT * FROM LoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 2";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

        ?>
            <a ><i class="icon-book"></i>
                <span><?php echo $row["TenLoaiSach"]; ?></span>
            </a>
        <?php
                                                            } //Đóng while
        ?>

        <ul>
        <?php
                        $sql = "SELECT * FROM ChiTietLoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 2";
                        $result = DataProvider::ExecuteQuery($sql);
                        while($row = mysql_fetch_array($result)){
            ?>

                                <li>
                                    <a href="index.php?a=6&dms=<?php echo $row["MaChiTietLoaiSach"]; ?> ">
                                        <span><?php echo $row["TenChiTietLoaiSach"]; ?></span>
                                    </a>
                                </li>


            <?php
                        }
            ?>
            </ul>
    </li>

    <li>
        <?php
                    $sql = "SELECT * FROM LoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 3";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

        ?>
            <a ><i class="icon-leaf"></i>
                <span><?php echo $row["TenLoaiSach"]; ?></span>
            </a>
        <?php
                                                            } //Đóng while
        ?>

        <ul>
        <?php
                        $sql = "SELECT * FROM ChiTietLoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 3";
                        $result = DataProvider::ExecuteQuery($sql);
                        while($row = mysql_fetch_array($result)){
            ?>

                                <li>
                                    <a href="index.php?a=6&dms=<?php echo $row["MaChiTietLoaiSach"]; ?> ">
                                        <span><?php echo $row["TenChiTietLoaiSach"]; ?></span>
                                    </a>
                                </li>


            <?php
                        }
            ?>
            </ul>
    </li>

    <li>
        <?php
                    $sql = "SELECT * FROM LoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 4";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

        ?>
            <a ><i class="icon-group"></i>
                <span><?php echo $row["TenLoaiSach"]; ?></span>
            </a>
        <?php
                                                            } //Đóng while
        ?>

        <ul>
        <?php
                        $sql = "SELECT * FROM ChiTietLoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 4";
                        $result = DataProvider::ExecuteQuery($sql);
                        while($row = mysql_fetch_array($result)){
            ?>

                                <li>
                                    <a href="index.php?a=6&dms=<?php echo $row["MaChiTietLoaiSach"]; ?> ">
                                        <span><?php echo $row["TenChiTietLoaiSach"]; ?></span>
                                    </a>
                                </li>


            <?php
                        }
            ?>
            </ul>
    </li>

    <li>
        <?php
                    $sql = "SELECT * FROM LoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 5";
                    $result = DataProvider::ExecuteQuery($sql);
                    while($row = mysql_fetch_array($result)){

        ?>
            <a ><i class="icon-suitcase"></i>
                <span><?php echo $row["TenLoaiSach"]; ?></span>
            </a>
        <?php
                                                            } //Đóng while
        ?>

        <ul>
        <?php
                        $sql = "SELECT * FROM ChiTietLoaiSach WHERE BiXoa = 0 AND MaLoaiSach = 5";
                        $result = DataProvider::ExecuteQuery($sql);
                        while($row = mysql_fetch_array($result)){
            ?>

                                <li>
                                    <a href="index.php?a=6&dms=<?php echo $row["MaChiTietLoaiSach"]; ?> ">
                                        <span><?php echo $row["TenChiTietLoaiSach"]; ?></span>
                                    </a>
                                </li>


            <?php
                        }
            ?>
            </ul>
    </li>
</ul>

<!-- Đã đổ CSDL vào, chưa liên kết tới trang khác